Dataset statistics
| Number of variables | 39 |
|---|---|
| Number of observations | 491 |
| Missing cells | 2092 |
| Missing cells (%) | 10.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 143.0 KiB |
| Average record size in memory | 298.3 B |
Variable types
| CAT | 24 |
|---|---|
| NUM | 11 |
| DATE | 2 |
| BOOL | 2 |
avobstime has a high cardinality: 183 distinct values | High cardinality |
avcomment has a high cardinality: 342 distinct values | High cardinality |
eded_time has a high cardinality: 189 distinct values | High cardinality |
ch_diff_cm is highly correlated with ch_max_cm and 1 other fields | High correlation |
ch_max_cm is highly correlated with ch_diff_cm | High correlation |
ch_min_cm is highly correlated with ch_diff_cm | High correlation |
deb_hwy_w is highly correlated with deb_hwy | High correlation |
deb_hwy is highly correlated with deb_hwy_w | High correlation |
avtrigger is highly correlated with avtriggertyp | High correlation |
avtriggertyp is highly correlated with avtrigger | High correlation |
edcr_ip is highly correlated with edcr_user | High correlation |
edcr_user is highly correlated with edcr_ip | High correlation |
eded_ip is highly correlated with eded_user | High correlation |
eded_user is highly correlated with eded_ip | High correlation |
avtype has 6 (1.2%) missing values | Missing |
avtriggertyp has 36 (7.3%) missing values | Missing |
avtrigger has 45 (9.2%) missing values | Missing |
avrelativesize has 17 (3.5%) missing values | Missing |
avdestructivesize has 50 (10.2%) missing values | Missing |
avinterface has 60 (12.2%) missing values | Missing |
sz_vert has 21 (4.3%) missing values | Missing |
sz_horiz has 38 (7.7%) missing values | Missing |
sz_aspect has 386 (78.6%) missing values | Missing |
term_longpath has 30 (6.1%) missing values | Missing |
term_shortPath has 165 (33.6%) missing values | Missing |
term_detail has 184 (37.5%) missing values | Missing |
term_moist has 113 (23.0%) missing values | Missing |
avcomment has 129 (26.3%) missing values | Missing |
edcr_user has 127 (25.9%) missing values | Missing |
edcr_ip has 98 (20.0%) missing values | Missing |
eded_user has 294 (59.9%) missing values | Missing |
eded_ip has 293 (59.7%) missing values | Missing |
avcomment is uniformly distributed | Uniform |
avrid has unique values | Unique |
sz_avgslope has 403 (82.1%) zeros | Zeros |
sz_elev_m has 242 (49.3%) zeros | Zeros |
term_elev_m has 208 (42.4%) zeros | Zeros |
av_vert_m has 248 (50.5%) zeros | Zeros |
crown_width_m has 342 (69.7%) zeros | Zeros |
ch_max_cm has 341 (69.5%) zeros | Zeros |
ch_min_cm has 341 (69.5%) zeros | Zeros |
ch_diff_cm has 342 (69.7%) zeros | Zeros |
deb_rail_w has 465 (94.7%) zeros | Zeros |
deb_rail_d has 465 (94.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-01-04 13:52:11.147170 |
|---|---|
| Analysis finished | 2023-01-04 13:52:42.686301 |
| Duration | 31.54 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 491 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 253.4032587 |
|---|---|
| Minimum | 1 |
| Maximum | 508 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 26.5 |
| Q1 | 127.5 |
| median | 250 |
| Q3 | 380.5 |
| 95-th percentile | 483.5 |
| Maximum | 508 |
| Range | 507 |
| Interquartile range (IQR) | 253 |
Descriptive statistics
| Standard deviation | 147.180551 |
|---|---|
| Coefficient of variation (CV) | 0.580815542 |
| Kurtosis | -1.203903522 |
| Mean | 253.4032587 |
| Median Absolute Deviation (MAD) | 127 |
| Skewness | 0.01891273965 |
| Sum | 124421 |
| Variance | 21662.1146 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 348 | 1 | 0.2% | |
| 346 | 1 | 0.2% | |
| 345 | 1 | 0.2% | |
| 344 | 1 | 0.2% | |
| 343 | 1 | 0.2% | |
| 342 | 1 | 0.2% | |
| 341 | 1 | 0.2% | |
| 339 | 1 | 0.2% | |
| 338 | 1 | 0.2% | |
| Other values (481) | 481 | 98.0% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 3 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 5 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 508 | 1 | 0.2% | |
| 507 | 1 | 0.2% | |
| 506 | 1 | 0.2% | |
| 505 | 1 | 0.2% | |
| 504 | 1 | 0.2% |
avpathid
Categorical
| Distinct | 48 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| PATH1163 | |
|---|---|
| INFINITY | |
| SHED10 | |
| SHED07W | |
| SHED11 | 23 |
| Other values (43) |
| Value | Count | Frequency (%) | |
| PATH1163 | 105 | 21.4% | |
| INFINITY | 58 | 11.8% | |
| SHED10 | 35 | 7.1% | |
| SHED07W | 28 | 5.7% | |
| SHED11 | 23 | 4.7% | |
| JAKES | 20 | 4.1% | |
| SHED07E | 17 | 3.5% | |
| SHED08 | 16 | 3.3% | |
| JAVA | 15 | 3.1% | |
| AP1163H | 14 | 2.9% | |
| Other values (38) | 160 | 32.6% |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | 1.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.910386965 |
| Min length | 2 |
avobsdate
Date
| Distinct | 209 |
|---|---|
| Distinct (%) | 42.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| Minimum | 2005-01-17 00:00:00 |
|---|---|
| Maximum | 2022-03-27 00:00:00 |
| Distinct | 183 |
|---|---|
| Distinct (%) | 37.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| 12:00:00 | 22 |
|---|---|
| 16:00:00 | 21 |
| 13:00:00 | 19 |
| 10:00:00 | 19 |
| 11:00:00 | 15 |
| Other values (178) |
| Value | Count | Frequency (%) | |
| 12:00:00 | 22 | 4.5% | |
| 16:00:00 | 21 | 4.3% | |
| 13:00:00 | 19 | 3.9% | |
| 10:00:00 | 19 | 3.9% | |
| 11:00:00 | 15 | 3.1% | |
| 15:30:00 | 12 | 2.4% | |
| 14:30:00 | 12 | 2.4% | |
| 10:30:00 | 12 | 2.4% | |
| 11:30:00 | 12 | 2.4% | |
| 09:00:00 | 11 | 2.2% | |
| Other values (173) | 336 | 68.4% |
Unique
| Unique | 111 ? |
|---|---|
| Unique (%) | 22.6% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
avobserverid
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| stein_01 | |
|---|---|
| clark_01 | |
| dunda_01 | 28 |
| Value | Count | Frequency (%) | |
| stein_01 | 307 | 62.5% | |
| clark_01 | 156 | 31.8% | |
| dunda_01 | 28 | 5.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 6 |
| Missing (%) | 1.2% |
| Memory size | 3.8 KiB |
| SS | |
|---|---|
| WL | |
| U | |
| L | |
| HS | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| SS | 234 | 47.7% | |
| WL | 78 | 15.9% | |
| U | 73 | 14.9% | |
| L | 44 | 9.0% | |
| HS | 29 | 5.9% | |
| WS | 20 | 4.1% | |
| C | 4 | 0.8% | |
| SU | 2 | 0.4% | |
| GS | 1 | 0.2% | |
| (Missing) | 6 | 1.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.765784114 |
| Min length | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 36 |
| Missing (%) | 7.3% |
| Memory size | 3.8 KiB |
| 5 | |
|---|---|
| 1 | 23 |
| 2 | 11 |
| Value | Count | Frequency (%) | |
| 5 | 421 | 85.7% | |
| 1 | 23 | 4.7% | |
| 2 | 11 | 2.2% | |
| (Missing) | 36 | 7.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 45 |
| Missing (%) | 9.2% |
| Memory size | 3.8 KiB |
| NU | |
|---|---|
| N | |
| NC | |
| AX | 18 |
| NL | 9 |
| Other values (6) | 16 |
| Value | Count | Frequency (%) | |
| NU | 202 | 41.1% | |
| N | 176 | 35.8% | |
| NC | 25 | 5.1% | |
| AX | 18 | 3.7% | |
| NL | 9 | 1.8% | |
| AS | 9 | 1.8% | |
| AH | 3 | 0.6% | |
| NS | 1 | 0.2% | |
| Asr | 1 | 0.2% | |
| AE | 1 | 0.2% | |
| (Missing) | 45 | 9.2% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.9% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.735234216 |
| Min length | 1 |
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 17 |
| Missing (%) | 3.5% |
| Memory size | 3.8 KiB |
| R2 | |
|---|---|
| R1 | |
| U | |
| R3 | |
| R4 | 16 |
| Value | Count | Frequency (%) | |
| R2 | 193 | 39.3% | |
| R1 | 106 | 21.6% | |
| U | 89 | 18.1% | |
| R3 | 69 | 14.1% | |
| R4 | 16 | 3.3% | |
| R5 | 1 | 0.2% | |
| (Missing) | 17 | 3.5% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.853360489 |
| Min length | 1 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 50 |
| Missing (%) | 10.2% |
| Memory size | 3.8 KiB |
| D2 | |
|---|---|
| D1.5 | |
| U | |
| D1 | |
| D2.5 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| D2 | 183 | 37.3% | |
| D1.5 | 98 | 20.0% | |
| U | 50 | 10.2% | |
| D1 | 43 | 8.8% | |
| D2.5 | 34 | 6.9% | |
| D3 | 29 | 5.9% | |
| D4 | 2 | 0.4% | |
| D3.5 | 2 | 0.4% | |
| (Missing) | 50 | 10.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 2 |
| Mean length | 2.545824847 |
| Min length | 1 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 60 |
| Missing (%) | 12.2% |
| Memory size | 3.8 KiB |
| U | |
|---|---|
| I | |
| O | |
| S | |
| G | 11 |
| Value | Count | Frequency (%) | |
| U | 174 | 35.4% | |
| I | 108 | 22.0% | |
| O | 98 | 20.0% | |
| S | 40 | 8.1% | |
| G | 11 | 2.2% | |
| (Missing) | 60 | 12.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.244399185 |
| Min length | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 21 |
| Missing (%) | 4.3% |
| Memory size | 3.8 KiB |
| T | |
|---|---|
| U | |
| M | |
| B | 13 |
| Value | Count | Frequency (%) | |
| T | 252 | 51.3% | |
| U | 121 | 24.6% | |
| M | 84 | 17.1% | |
| B | 13 | 2.6% | |
| (Missing) | 21 | 4.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.085539715 |
| Min length | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 38 |
| Missing (%) | 7.7% |
| Memory size | 3.8 KiB |
| U | |
|---|---|
| C | |
| L | |
| R |
| Value | Count | Frequency (%) | |
| U | 155 | 31.6% | |
| C | 144 | 29.3% | |
| L | 81 | 16.5% | |
| R | 73 | 14.9% | |
| (Missing) | 38 | 7.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.154786151 |
| Min length | 1 |
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.99185336 |
|---|---|
| Minimum | 0 |
| Maximum | 45 |
| Zeros | 403 |
| Zeros (%) | 82.1% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 40 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 15.02242999 |
|---|---|
| Coefficient of variation (CV) | 2.148561936 |
| Kurtosis | 0.9394864018 |
| Mean | 6.99185336 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.701270512 |
| Sum | 3433 |
| Variance | 225.6734029 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 403 | 82.1% | |
| 40 | 38 | 7.7% | |
| 38 | 14 | 2.9% | |
| 35 | 11 | 2.2% | |
| 37 | 8 | 1.6% | |
| 45 | 7 | 1.4% | |
| 42 | 5 | 1.0% | |
| 34 | 4 | 0.8% | |
| 39 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 403 | 82.1% | |
| 34 | 4 | 0.8% | |
| 35 | 11 | 2.2% | |
| 37 | 8 | 1.6% | |
| 38 | 14 | 2.9% |
| Value | Count | Frequency (%) | |
| 45 | 7 | 1.4% | |
| 42 | 5 | 1.0% | |
| 40 | 38 | 7.7% | |
| 39 | 1 | 0.2% | |
| 38 | 14 | 2.9% |
| Distinct | 116 |
|---|---|
| Distinct (%) | 23.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 947.7169043 |
|---|---|
| Minimum | 0 |
| Maximum | 5000 |
| Zeros | 242 |
| Zeros (%) | 49.3% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1280 |
| Q3 | 1866.5 |
| 95-th percentile | 2165 |
| Maximum | 5000 |
| Range | 5000 |
| Interquartile range (IQR) | 1866.5 |
Descriptive statistics
| Standard deviation | 960.7033772 |
|---|---|
| Coefficient of variation (CV) | 1.013702903 |
| Kurtosis | -1.321936134 |
| Mean | 947.7169043 |
| Median Absolute Deviation (MAD) | 1038 |
| Skewness | 0.1912887326 |
| Sum | 465329 |
| Variance | 922950.9789 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 242 | 49.3% | |
| 1830 | 12 | 2.4% | |
| 1818 | 12 | 2.4% | |
| 1939 | 8 | 1.6% | |
| 1890 | 7 | 1.4% | |
| 1700 | 7 | 1.4% | |
| 1800 | 7 | 1.4% | |
| 1697 | 7 | 1.4% | |
| 2000 | 5 | 1.0% | |
| 1950 | 5 | 1.0% | |
| Other values (106) | 179 | 36.5% |
| Value | Count | Frequency (%) | |
| 0 | 242 | 49.3% | |
| 1250 | 1 | 0.2% | |
| 1273 | 1 | 0.2% | |
| 1280 | 3 | 0.6% | |
| 1306 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 5000 | 1 | 0.2% | |
| 2348 | 1 | 0.2% | |
| 2345 | 1 | 0.2% | |
| 2318 | 1 | 0.2% | |
| 2285 | 1 | 0.2% |
| Distinct | 7 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 386 |
| Missing (%) | 78.6% |
| Memory size | 3.8 KiB |
| N | |
|---|---|
| SE | |
| S | |
| SW | |
| E | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| N | 45 | 9.2% | |
| SE | 18 | 3.7% | |
| S | 17 | 3.5% | |
| SW | 11 | 2.2% | |
| E | 9 | 1.8% | |
| NE | 4 | 0.8% | |
| W | 1 | 0.2% | |
| (Missing) | 386 | 78.6% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 1.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.639511202 |
| Min length | 1 |
| Distinct | 112 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 878.1425662 |
|---|---|
| Minimum | 0 |
| Maximum | 4550 |
| Zeros | 208 |
| Zeros (%) | 42.4% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1310 |
| Q3 | 1460 |
| 95-th percentile | 1787.5 |
| Maximum | 4550 |
| Range | 4550 |
| Interquartile range (IQR) | 1460 |
Descriptive statistics
| Standard deviation | 811.5932605 |
|---|---|
| Coefficient of variation (CV) | 0.9242158298 |
| Kurtosis | 0.9436597264 |
| Mean | 878.1425662 |
| Median Absolute Deviation (MAD) | 390 |
| Skewness | 0.464230436 |
| Sum | 431168 |
| Variance | 658683.6204 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 208 | 42.4% | |
| 1400 | 31 | 6.3% | |
| 1515 | 11 | 2.2% | |
| 1460 | 10 | 2.0% | |
| 1370 | 10 | 2.0% | |
| 1455 | 9 | 1.8% | |
| 1394 | 8 | 1.6% | |
| 1333 | 7 | 1.4% | |
| 1697 | 7 | 1.4% | |
| 1353 | 7 | 1.4% | |
| Other values (102) | 183 | 37.3% |
| Value | Count | Frequency (%) | |
| 0 | 208 | 42.4% | |
| 1030 | 1 | 0.2% | |
| 1067 | 1 | 0.2% | |
| 1152 | 1 | 0.2% | |
| 1190 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 4550 | 1 | 0.2% | |
| 4400 | 3 | 0.6% | |
| 2150 | 1 | 0.2% | |
| 2134 | 1 | 0.2% | |
| 2100 | 1 | 0.2% |
| Distinct | 151 |
|---|---|
| Distinct (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 200.9450102 |
|---|---|
| Minimum | 0 |
| Maximum | 2285 |
| Zeros | 248 |
| Zeros (%) | 50.5% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 344.5 |
| 95-th percentile | 726 |
| Maximum | 2285 |
| Range | 2285 |
| Interquartile range (IQR) | 344.5 |
Descriptive statistics
| Standard deviation | 320.9309021 |
|---|---|
| Coefficient of variation (CV) | 1.597108093 |
| Kurtosis | 12.6963222 |
| Mean | 200.9450102 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.92749673 |
| Sum | 98664 |
| Variance | 102996.6439 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 248 | 50.5% | |
| 60 | 9 | 1.8% | |
| 303 | 5 | 1.0% | |
| 430 | 5 | 1.0% | |
| 30 | 5 | 1.0% | |
| 370 | 4 | 0.8% | |
| 490 | 4 | 0.8% | |
| 300 | 4 | 0.8% | |
| 182 | 4 | 0.8% | |
| 765 | 4 | 0.8% | |
| Other values (141) | 199 | 40.5% |
| Value | Count | Frequency (%) | |
| 0 | 248 | 50.5% | |
| 8 | 1 | 0.2% | |
| 15 | 1 | 0.2% | |
| 30 | 5 | 1.0% | |
| 31 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 2285 | 1 | 0.2% | |
| 2042 | 1 | 0.2% | |
| 2015 | 1 | 0.2% | |
| 1951 | 1 | 0.2% | |
| 1939 | 1 | 0.2% |
| Distinct | 37 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.05906314 |
|---|---|
| Minimum | 0 |
| Maximum | 1972 |
| Zeros | 342 |
| Zeros (%) | 69.7% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 150 |
| Maximum | 1972 |
| Range | 1972 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 117.0268527 |
|---|---|
| Coefficient of variation (CV) | 3.65035161 |
| Kurtosis | 160.0694173 |
| Mean | 32.05906314 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.78193889 |
| Sum | 15741 |
| Variance | 13695.28426 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 342 | 69.7% | |
| 30 | 23 | 4.7% | |
| 20 | 23 | 4.7% | |
| 60 | 13 | 2.6% | |
| 40 | 12 | 2.4% | |
| 100 | 12 | 2.4% | |
| 50 | 10 | 2.0% | |
| 200 | 6 | 1.2% | |
| 70 | 6 | 1.2% | |
| 150 | 5 | 1.0% | |
| Other values (27) | 39 | 7.9% |
| Value | Count | Frequency (%) | |
| 0 | 342 | 69.7% | |
| 4 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 15 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 1972 | 1 | 0.2% | |
| 800 | 1 | 0.2% | |
| 650 | 1 | 0.2% | |
| 500 | 1 | 0.2% | |
| 424 | 1 | 0.2% |
| Distinct | 21 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.90835031 |
|---|---|
| Minimum | 0 |
| Maximum | 300 |
| Zeros | 341 |
| Zeros (%) | 69.5% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 30 |
| 95-th percentile | 120 |
| Maximum | 300 |
| Range | 300 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 44.06513907 |
|---|---|
| Coefficient of variation (CV) | 2.011339898 |
| Kurtosis | 8.9186803 |
| Mean | 21.90835031 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.751736118 |
| Sum | 10757 |
| Variance | 1941.736481 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 341 | 69.5% | |
| 30 | 31 | 6.3% | |
| 60 | 24 | 4.9% | |
| 45 | 13 | 2.6% | |
| 75 | 9 | 1.8% | |
| 100 | 9 | 1.8% | |
| 90 | 9 | 1.8% | |
| 150 | 8 | 1.6% | |
| 40 | 8 | 1.6% | |
| 50 | 7 | 1.4% | |
| Other values (11) | 32 | 6.5% |
| Value | Count | Frequency (%) | |
| 0 | 341 | 69.5% | |
| 12 | 1 | 0.2% | |
| 15 | 1 | 0.2% | |
| 20 | 6 | 1.2% | |
| 25 | 4 | 0.8% |
| Value | Count | Frequency (%) | |
| 300 | 1 | 0.2% | |
| 250 | 2 | 0.4% | |
| 200 | 6 | 1.2% | |
| 180 | 1 | 0.2% | |
| 150 | 8 | 1.6% |
| Distinct | 22 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.6395112 |
|---|---|
| Minimum | 0 |
| Maximum | 300 |
| Zeros | 341 |
| Zeros (%) | 69.5% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 60 |
| Maximum | 300 |
| Range | 300 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 27.14921705 |
|---|---|
| Coefficient of variation (CV) | 2.14796416 |
| Kurtosis | 29.03558084 |
| Mean | 12.6395112 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.137396896 |
| Sum | 6206 |
| Variance | 737.0799867 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 341 | 69.5% | |
| 30 | 43 | 8.8% | |
| 20 | 26 | 5.3% | |
| 60 | 15 | 3.1% | |
| 25 | 10 | 2.0% | |
| 50 | 10 | 2.0% | |
| 15 | 9 | 1.8% | |
| 10 | 7 | 1.4% | |
| 100 | 6 | 1.2% | |
| 75 | 5 | 1.0% | |
| Other values (12) | 19 | 3.9% |
| Value | Count | Frequency (%) | |
| 0 | 341 | 69.5% | |
| 4 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 10 | 7 | 1.4% | |
| 12 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 300 | 1 | 0.2% | |
| 150 | 1 | 0.2% | |
| 130 | 1 | 0.2% | |
| 120 | 3 | 0.6% | |
| 100 | 6 | 1.2% |
| Distinct | 40 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.17922607 |
|---|---|
| Minimum | 0 |
| Maximum | 210 |
| Zeros | 342 |
| Zeros (%) | 69.7% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 25 |
| 95-th percentile | 84 |
| Maximum | 210 |
| Range | 210 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 33.94804638 |
|---|---|
| Coefficient of variation (CV) | 1.976110347 |
| Kurtosis | 8.203302986 |
| Mean | 17.17922607 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.652361859 |
| Sum | 8435 |
| Variance | 1152.469853 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 342 | 69.7% | |
| 30 | 20 | 4.1% | |
| 45 | 19 | 3.9% | |
| 75 | 14 | 2.9% | |
| 25 | 11 | 2.2% | |
| 38 | 10 | 2.0% | |
| 60 | 6 | 1.2% | |
| 23 | 5 | 1.0% | |
| 65 | 5 | 1.0% | |
| 20 | 5 | 1.0% | |
| Other values (30) | 54 | 11.0% |
| Value | Count | Frequency (%) | |
| 0 | 342 | 69.7% | |
| 7 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| 15 | 2 | 0.4% | |
| 18 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 210 | 1 | 0.2% | |
| 200 | 2 | 0.4% | |
| 175 | 1 | 0.2% | |
| 165 | 1 | 0.2% | |
| 150 | 1 | 0.2% |
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 30 |
| Missing (%) | 6.1% |
| Memory size | 3.8 KiB |
| TK | |
|---|---|
| U | |
| BR | |
| TR | |
| MR | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| TK | 163 | 33.2% | |
| U | 98 | 20.0% | |
| BR | 81 | 16.5% | |
| TR | 72 | 14.7% | |
| MR | 30 | 6.1% | |
| SZ | 14 | 2.9% | |
| - | 3 | 0.6% | |
| (Missing) | 30 | 6.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.855397149 |
| Min length | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 165 |
| Missing (%) | 33.6% |
| Memory size | 3.8 KiB |
| - | |
|---|---|
| BP | |
| MP | 4 |
| TP | 4 |
| Value | Count | Frequency (%) | |
| - | 262 | 53.4% | |
| BP | 56 | 11.4% | |
| MP | 4 | 0.8% | |
| TP | 4 | 0.8% | |
| (Missing) | 165 | 33.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.802443992 |
| Min length | 1 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 184 |
| Missing (%) | 37.5% |
| Memory size | 3.8 KiB |
| U | |
|---|---|
| 1F | 6 |
| 2F | 5 |
| - | 4 |
| 3F | 4 |
| Value | Count | Frequency (%) | |
| U | 288 | 58.7% | |
| 1F | 6 | 1.2% | |
| 2F | 5 | 1.0% | |
| - | 4 | 0.8% | |
| 3F | 4 | 0.8% | |
| (Missing) | 184 | 37.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.780040733 |
| Min length | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 113 |
| Missing (%) | 23.0% |
| Memory size | 3.8 KiB |
| U | |
|---|---|
| W | |
| D | |
| M |
| Value | Count | Frequency (%) | |
| U | 157 | 32.0% | |
| W | 97 | 19.8% | |
| D | 80 | 16.3% | |
| M | 44 | 9.0% | |
| (Missing) | 113 | 23.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.460285132 |
| Min length | 1 |
deb_rail
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 491.0 B |
| False | |
|---|---|
| True | 38 |
| Value | Count | Frequency (%) | |
| False | 453 | 92.3% | |
| True | 38 | 7.7% |
| Distinct | 14 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.018329939 |
|---|---|
| Minimum | 0 |
| Maximum | 130 |
| Zeros | 465 |
| Zeros (%) | 94.7% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.5 |
| Maximum | 130 |
| Range | 130 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.82481264 |
|---|---|
| Coefficient of variation (CV) | 5.858711408 |
| Kurtosis | 70.44125528 |
| Mean | 2.018329939 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.970272345 |
| Sum | 991 |
| Variance | 139.8261939 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 465 | 94.7% | |
| 20 | 7 | 1.4% | |
| 30 | 6 | 1.2% | |
| 100 | 2 | 0.4% | |
| 10 | 2 | 0.4% | |
| 120 | 1 | 0.2% | |
| 40 | 1 | 0.2% | |
| 130 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| Other values (4) | 4 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 465 | 94.7% | |
| 4 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 7 | 1 | 0.2% | |
| 10 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 130 | 1 | 0.2% | |
| 120 | 1 | 0.2% | |
| 100 | 2 | 0.4% | |
| 80 | 1 | 0.2% | |
| 50 | 1 | 0.2% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1177189409 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros | 465 |
| Zeros (%) | 94.7% |
| Memory size | 3.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.2 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.025427582 |
|---|---|
| Coefficient of variation (CV) | 8.710812154 |
| Kurtosis | 296.880219 |
| Mean | 0.1177189409 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.10793276 |
| Sum | 57.8 |
| Variance | 1.051501725 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 465 | 94.7% | |
| 2 | 5 | 1.0% | |
| 0.2 | 4 | 0.8% | |
| 0.5 | 4 | 0.8% | |
| 1 | 4 | 0.8% | |
| 1.5 | 3 | 0.6% | |
| 8 | 1 | 0.2% | |
| 20 | 1 | 0.2% | |
| 0.8 | 1 | 0.2% | |
| 0.7 | 1 | 0.2% | |
| Other values (2) | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 0 | 465 | 94.7% | |
| 0.2 | 4 | 0.8% | |
| 0.5 | 4 | 0.8% | |
| 0.7 | 1 | 0.2% | |
| 0.8 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 20 | 1 | 0.2% | |
| 8 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 3 | 1 | 0.2% | |
| 2 | 5 | 1.0% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 491.0 B |
| False | |
|---|---|
| True | 5 |
| Value | Count | Frequency (%) | |
| False | 486 | 99.0% | |
| True | 5 | 1.0% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| 0 | |
|---|---|
| 20 | 2 |
| 30 | 2 |
| 10 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 486 | 99.0% | |
| 20 | 2 | 0.4% | |
| 30 | 2 | 0.4% | |
| 10 | 1 | 0.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.010183299 |
| Min length | 3 |
deb_hwy_d
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| 0 | |
|---|---|
| 20 | 2 |
| 0.1 | 2 |
| 0.2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 486 | 99.0% | |
| 20 | 2 | 0.4% | |
| 0.1 | 2 | 0.4% | |
| 0.2 | 1 | 0.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.00407332 |
| Min length | 3 |
| Distinct | 342 |
|---|---|
| Distinct (%) | 94.5% |
| Missing | 129 |
| Missing (%) | 26.3% |
| Memory size | 3.8 KiB |
| Debris terminated above the rail. | 5 |
|---|---|
| Debris ran 2/3 path terminating above the grade. | 5 |
| Debris ran 1/2 path terminating above the rail. | 3 |
| Time is approximate. Debris fully across main 1 and partially across main 2. | 3 |
| Debris ran 1/2 path terminating above the grade. | 2 |
| Other values (337) |
| Value | Count | Frequency (%) | |
| Debris terminated above the rail. | 5 | 1.0% | |
| Debris ran 2/3 path terminating above the grade. | 5 | 1.0% | |
| Debris ran 1/2 path terminating above the rail. | 3 | 0.6% | |
| Time is approximate. Debris fully across main 1 and partially across main 2. | 3 | 0.6% | |
| Debris ran 1/2 path terminating above the grade. | 2 | 0.4% | |
| Time is approximate. Debris across both mains. | 2 | 0.4% | |
| Debris terminated on the grade covering Main 1. | 2 | 0.4% | |
| Debris ran 2/3 path terminating above the rail. | 2 | 0.4% | |
| Likely triggered by warm air temperatures and high elevation rain. | 2 | 0.4% | |
| Debris terminated above the grade. | 2 | 0.4% | |
| Other values (332) | 334 | 68.0% | |
| (Missing) | 129 | 26.3% |
Unique
| Unique | 330 ? |
|---|---|
| Unique (%) | 91.2% |
Length
| Max length | 456 |
|---|---|
| Median length | 47 |
| Mean length | 63.28309572 |
| Min length | 3 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 127 |
| Missing (%) | 25.9% |
| Memory size | 3.8 KiB |
| Ted | |
|---|---|
| Adam | |
| ed | |
| Steiner | 10 |
| Value | Count | Frequency (%) | |
| Ted | 163 | 33.2% | |
| Adam | 160 | 32.6% | |
| ed | 31 | 6.3% | |
| Steiner | 10 | 2.0% | |
| (Missing) | 127 | 25.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.344195519 |
| Min length | 2 |
edcr_time
Date
| Distinct | 244 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| Minimum | 2016-03-17 11:50:56 |
|---|---|
| Maximum | 2022-03-28 16:37:03 |
| Distinct | 20 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 98 |
| Missing (%) | 20.0% |
| Memory size | 3.8 KiB |
| 10.173.132.4 | |
|---|---|
| 139.51.15.17 | |
| 139.51.15.19 | |
| 139.51.15.22 | |
| 139.51.15.20 | |
| Other values (15) |
| Value | Count | Frequency (%) | |
| 10.173.132.4 | 58 | 11.8% | |
| 139.51.15.17 | 55 | 11.2% | |
| 139.51.15.19 | 38 | 7.7% | |
| 139.51.15.22 | 35 | 7.1% | |
| 139.51.15.20 | 32 | 6.5% | |
| 10.30.72.4 | 28 | 5.7% | |
| ed | 26 | 5.3% | |
| 10.173.132.2 | 26 | 5.3% | |
| 64.91.61.64 | 21 | 4.3% | |
| 10.173.132.15 | 19 | 3.9% | |
| Other values (10) | 55 | 11.2% | |
| (Missing) | 98 | 20.0% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 1.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 9.437881874 |
| Min length | 2 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 294 |
| Missing (%) | 59.9% |
| Memory size | 3.8 KiB |
| Adam | |
|---|---|
| Ted | |
| ed |
| Value | Count | Frequency (%) | |
| Adam | 97 | 19.8% | |
| Ted | 89 | 18.1% | |
| ed | 11 | 2.2% | |
| (Missing) | 294 | 59.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.175152749 |
| Min length | 2 |
| Distinct | 189 |
|---|---|
| Distinct (%) | 38.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 KiB |
| 0000-00-00 00:00:00 | |
|---|---|
| 2019-01-02 00:00:00 | 11 |
| 2020-01-17 17:51:14 | 1 |
| 2022-03-08 01:00:55 | 1 |
| 2019-03-22 15:26:42 | 1 |
| Other values (184) |
| Value | Count | Frequency (%) | |
| 0000-00-00 00:00:00 | 293 | 59.7% | |
| 2019-01-02 00:00:00 | 11 | 2.2% | |
| 2020-01-17 17:51:14 | 1 | 0.2% | |
| 2022-03-08 01:00:55 | 1 | 0.2% | |
| 2019-03-22 15:26:42 | 1 | 0.2% | |
| 2019-12-17 13:33:47 | 1 | 0.2% | |
| 2019-12-20 16:46:49 | 1 | 0.2% | |
| 2019-12-23 23:47:00 | 1 | 0.2% | |
| 2020-01-01 20:22:18 | 1 | 0.2% | |
| 2020-01-01 19:44:43 | 1 | 0.2% | |
| Other values (179) | 179 | 36.5% |
Unique
| Unique | 187 ? |
|---|---|
| Unique (%) | 38.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 293 |
| Missing (%) | 59.7% |
| Memory size | 3.8 KiB |
| 64.91.61.64 | |
|---|---|
| 139.51.15.17 | |
| 139.51.15.19 | |
| 184.166.43.50 | |
| server | |
| Other values (5) |
| Value | Count | Frequency (%) | |
| 64.91.61.64 | 73 | 14.9% | |
| 139.51.15.17 | 49 | 10.0% | |
| 139.51.15.19 | 26 | 5.3% | |
| 184.166.43.50 | 14 | 2.9% | |
| server | 11 | 2.2% | |
| 139.51.15.22 | 7 | 1.4% | |
| 139.51.15.20 | 6 | 1.2% | |
| 10.30.72.4 | 6 | 1.2% | |
| 170.49.113.19 | 3 | 0.6% | |
| 170.49.113.17 | 3 | 0.6% | |
| (Missing) | 293 | 59.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 6.362525458 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| avrid | avpathid | avobsdate | avobstime | avobserverid | avtype | avtriggertyp | avtrigger | avrelativesize | avdestructivesize | avinterface | sz_vert | sz_horiz | sz_avgslope | sz_elev_m | sz_aspect | term_elev_m | av_vert_m | crown_width_m | ch_max_cm | ch_min_cm | ch_diff_cm | term_longpath | term_shortPath | term_detail | term_moist | deb_rail | deb_rail_w | deb_rail_d | deb_hwy | deb_hwy_w | deb_hwy_d | avcomment | edcr_user | edcr_time | edcr_ip | eded_user | eded_time | eded_ip | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | SHED10 | 2012-03-26 | 12:45:00 | stein_01 | WS | 5.0 | NL | R1 | D1.5 | O | B | R | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TK | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Wet slab released on SE aspect @ 5400 feet (1636 m) elevation. Debris ran 2/3rds path to at least 4,600 feet (1394 m) elevation. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 1 | 2 | PATH1163 | 2012-03-16 | 08:30:00 | stein_01 | U | 5.0 | NU | U | D2 | U | U | U | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TK | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Wet debris ran 2/3 path in main path to 4700 feet (1424 m) elevation. Upper SZ obscured. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 2 | 3 | CURLY | 2012-03-16 | 08:34:00 | stein_01 | U | 5.0 | NU | U | D1 | U | U | U | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TR | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Terminus at canyon floor elevation.\r\n\r\nDebris wet and relatively small amount. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 3 | 4 | SHED10 | 2012-03-10 | 14:50:00 | stein_01 | WL | 5.0 | NaN | R2 | D1 | I | M | R | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TK | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | D1.5 | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 4 | 5 | INFINITY | 2012-03-10 | 14:54:00 | stein_01 | L | 5.0 | N | R2 | D1 | I | T | C | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TK | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | D1.5- 1/2 Path. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 5 | 6 | SECOND | 2012-03-05 | 11:45:00 | stein_01 | SS | 5.0 | N | R2 | D1 | I | T | C | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | NaN | BP | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | SS-NC-R2D 1.5-I on east aspect of Second Slide's looker's right ridge. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 6 | 7 | BURNOUT | 2012-03-03 | 01:30:00 | stein_01 | SS | 5.0 | N | R1 | D1 | I | M | L | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | NaN | BP | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Debris did not make the rail grade. | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 7 | 8 | SHED09L | 2012-02-28 | 11:16:00 | stein_01 | SS | 5.0 | NS | R2 | D2 | I | T | L | 0 | 2000 | NaN | 1424 | 576 | 48 | 45 | 30 | 38 | MR | - | U | M | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Likely triggered by avalanche in Shed 9 upper SZ.\nCrown width - 160 feet\nCrown depth - 12-18 inches\nDebris - 2/3 path\nCrown line - 6600'\nTerminus of debris - 4700'\nAspect - SE\n | ed | 2016-03-17 11:50:56 | 10.173.132.2 | Ted | 2020-05-12 20:41:17 | 64.91.61.64 |
| 8 | 9 | INFINITY | 2012-02-28 | 11:09:00 | dunda_01 | SS | 5.0 | N | R2 | D1 | I | T | R | 0 | 0 | NaN | 0 | 0 | 0 | 0 | 0 | 0 | TK | NaN | NaN | NaN | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Fracture line - 6400' | ed | 2016-03-17 11:50:56 | 10.173.132.2 | NaN | 0000-00-00 00:00:00 | NaN |
| 9 | 10 | SHED09 | 2012-02-28 | 11:16:00 | stein_01 | HS | 5.0 | N | R3 | D2 | O | T | C | 34 | 2045 | NaN | 1712 | 333 | 424 | 100 | 30 | 65 | TK | - | U | D | False | 0.0 | 0.0 | False | 0.0 | 0.0 | <b>Upper Shed 9</b>\n\nFracture line - 6750'\nDebris toe - 5650'\nAspect - South through East\nCrown depth - 12"- 36"\nCrown width - 1400' \nStarting zone horizontal - left and center \nLikely wildlife trigger | ed | 2016-03-17 11:50:56 | 10.173.132.2 | Ted | 2020-05-12 21:28:02 | 64.91.61.64 |
Last rows
| avrid | avpathid | avobsdate | avobstime | avobserverid | avtype | avtriggertyp | avtrigger | avrelativesize | avdestructivesize | avinterface | sz_vert | sz_horiz | sz_avgslope | sz_elev_m | sz_aspect | term_elev_m | av_vert_m | crown_width_m | ch_max_cm | ch_min_cm | ch_diff_cm | term_longpath | term_shortPath | term_detail | term_moist | deb_rail | deb_rail_w | deb_rail_d | deb_hwy | deb_hwy_w | deb_hwy_d | avcomment | edcr_user | edcr_time | edcr_ip | eded_user | eded_time | eded_ip | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 481 | 499 | SHED09L | 2022-03-01 | 12:20:00 | clark_01 | WL | 5.0 | NU | R2 | D2 | I | T | C | 40 | 1710 | SW | 1400 | 310 | 0 | 0 | 0 | 0 | MR | - | U | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | NaN | Adam | 2022-03-01 16:41:19 | 170.49.113.17 | NaN | 0000-00-00 00:00:00 | NaN |
| 482 | 500 | FRYPAN | 2022-03-01 | 14:41:00 | clark_01 | WL | 5.0 | NU | R2 | D2 | I | T | C | 0 | 1850 | NE | 1460 | 390 | 0 | 0 | 0 | 0 | MR | - | U | U | False | 0.0 | 0.0 | False | 0.0 | 0.0 | SZ elevation estimated | Adam | 2022-03-01 16:43:55 | 170.49.113.17 | NaN | 0000-00-00 00:00:00 | NaN |
| 483 | 501 | AP1183 | 2022-03-01 | 05:00:00 | clark_01 | SS | 5.0 | NU | R3 | D2.5 | I | T | R | 38 | 1737 | NE | 1067 | 670 | 215 | 100 | 35 | 68 | BR | - | 1F | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | 1st observed on Mar. 2nd. then investigated the starting zone on Mar.7th. First initiated as a storm slab that failed at the new/old snow interface. Debris entrained a lot of wet snow on the way down and it was wet debris at the terminus which reached about 100 yards from the rail. | Adam | 2022-03-08 17:43:16 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 484 | 502 | INFINITY | 2022-03-02 | 11:35:00 | clark_01 | WL | 5.0 | N | R2 | D1.5 | I | T | C | 40 | 1800 | S | 1400 | 400 | 0 | 0 | 0 | 0 | TR | - | U | U | False | 0.0 | 0.0 | False | 0.0 | 0.0 | One of the last avalanches observed during the Feb 28-Mar 2 cycle. | Adam | 2022-03-15 13:38:53 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 485 | 503 | PATH1163 | 2022-03-17 | 19:02:00 | clark_01 | WL | 5.0 | NU | R1 | D1.5 | S | M | L | 40 | 1830 | SE | 1550 | 280 | 0 | 0 | 0 | 0 | TK | - | U | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | NaN | Adam | 2022-03-17 21:04:31 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 486 | 504 | SHED07W | 2022-03-01 | 05:04:00 | clark_01 | SS | 5.0 | NC | R2 | D2 | I | T | L | 38 | 2015 | E | 1760 | 255 | 0 | 0 | 0 | 0 | TK | - | U | U | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Slab not observed until March 17th during a ski tour and could barely make out remnants of the crown. But this cornice fall was noted on March 1st, | Adam | 2022-03-17 21:17:04 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 487 | 505 | AP1163H | 2022-03-23 | 13:30:00 | clark_01 | WL | 5.0 | NU | R1 | D1.5 | O | T | U | 0 | 1830 | SW | 1460 | 370 | 0 | 0 | 0 | 0 | TR | - | U | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | NaN | Adam | 2022-03-23 21:32:42 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 488 | 506 | SHED10 | 2022-03-23 | 13:30:00 | clark_01 | WL | 5.0 | N | R2 | D2 | O | T | C | 40 | 2075 | SE | 1646 | 429 | 0 | 0 | 0 | 0 | TK | - | U | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Obs on Mar. 24th from Hwy | Adam | 2022-03-28 16:30:35 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 489 | 507 | MCAMSER | 2022-03-23 | 18:00:00 | clark_01 | HS | 5.0 | NC | R3 | D3 | O | T | C | 40 | 2195 | SE | 1790 | 405 | 245 | 150 | 40 | 95 | MR | - | U | U | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Obs on Mar. 24th from Hwy. Could not see runout from Hwy so runout details are estimated. | Adam | 2022-03-28 16:34:43 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |
| 490 | 508 | PATH1163 | 2022-03-27 | 14:35:00 | clark_01 | WL | 5.0 | N | R1 | D2 | O | T | L | 40 | 2135 | SE | 1400 | 735 | 0 | 0 | 0 | 0 | MR | - | U | W | False | 0.0 | 0.0 | False | 0.0 | 0.0 | Obs. on Mar. 28th from Hwy. | Adam | 2022-03-28 16:37:03 | 10.30.72.4 | NaN | 0000-00-00 00:00:00 | NaN |